<?php
/* -------------------------------------------------------------------------------------
* 	ID:						$Id: install_step_3.php 136 2013-09-22 07:38:55Z phone.mueller@googlemail.com $
* 	Letzter Stand:			$Revision: 136 $
* 	zuletzt geaendert von:	$Author: siekiera $
* 	Datum:					$Date: 2013-09-22 07:38:55 +0000 (Sun, 22 Sep 2013) $
*
* 	SEO:mercari by Siekiera Media
* 	http://www.seo-mercari.de
*
* 	Copyright (c) since 2011 SEO:mercari
* --------------------------------------------------------------------------------------
* 	based on:
* 	(c) 2000-2001 The Exchange Project  (earlier name of osCommerce)
* 	(c) 2002-2003 osCommerce - www.oscommerce.com
* 	(c) 2003     nextcommerce - www.nextcommerce.org
* 	(c) 2005     xt:Commerce - www.xt-commerce.com
*
* 	Released under the GNU General Public License
* ----------------------------------------------------------------------------------- */

if(!defined('VALID_INSTALLER'))
	header('Location: ../../');

$db = new mercari_db();

$configuration = $db->db_query("SELECT configuration_key, configuration_value FROM ".TABLE_CONFIGURATION);
while(!$configuration->EOF) {
	define($configuration->fields['configuration_key'], $configuration->fields['configuration_value']);
	$configuration->MoveNext();
}

@chmod(DIR_FS_CATALOG.'includes/configure.php', 0444);
@chmod(DIR_FS_CATALOG.'admin/includes/configure.php', 0444);

$message_stack = new message_stack();

require(DIR_FS_CATALOG.'includes/classes/class.input_fields.php');

$field = new input_fields('create_account', $_POST);

if(isset($_POST)) {
	$_SESSION['languages_id'] = 1;
	require(DIR_FS_CATALOG.'lang/german/german.php');
}
$gender_male = $field->getField('gender', 'm', (!isset($_POST) ? ' checked=""' : ''));
$gender_female = $field->getField('gender', 'f');
$title = $field->getField('title', '', 'size="6"');
$firstname = $field->getField('firstname');
$lastname = $field->getField('lastname');
$dob = $field->getField('dob');
$email_address = $field->getField('email', '', 'id="mail_address" onkeyup="setMailAdress()"');
$company = $field->getField('company');
$street_address = $field->getField('street_address', '', 'size="21" class="create_account_street"');
$street_address_num = $field->getField('street_address_num', '', 'size="3" class="create_account_street_num"');
$postcode = $field->getField('postcode', '', 'size="5"  class="create_account_postcode"');
$city = $field->getField('city', '', 'size="19" class="create_account_city"');
$state = $field->getField('state', '', 'class="create_account_state"');
$country = $field->getField('country', '', 'class="create_account_state" id="country"');
$telephone = $field->getField('telephone');
$fax = $field->getField('fax');
$password = $field->getField('password', '', 'id="pass"');
$confirmation = $field->getField('confirmation', '', 'id="pass2"');

$store_name = $_POST['STORE_NAME'];

if (strlen($store_name) < '3') {
	$field->error == 'true';
	$message_stack->add('install_step3', ENTRY_STORE_NAME_ERROR);
}

if(isset($_POST['action']) && ($_POST['action'] == 'process') && $field->error != 'true') {
	require(DIR_FS_INC.'inc.date_raw.php');
	
	$sql_data_array = array('customers_id' => '1',
							'customers_status' => '0',
							'customers_firstname' => (!empty($field->post_vars['title']) ? $field->post_vars['title'].' ' : '' ).ucfirst(strtolower($field->post_vars['firstname'])),
							'customers_lastname' => ucfirst(strtolower($field->post_vars['lastname'])),
							'customers_email_address' => $field->post_vars['email'],
							'customers_default_address_id' => '1',
							'customers_telephone' => $field->post_vars['telephone'],
							'customers_fax' => $field->post_vars['fax'],
							'customers_newsletter' => '1',
							'customers_password' => encrypt_password($field->post_vars['password']),
							'customers_date_added' => 'NOW()',
							'customers_last_modified' => 'NOW()',
							'delete_user' => '0',
							'admin_id' => '1');
	
	if (!empty($field->post_vars['gender']))
		$sql_data_array['customers_gender'] = $field->post_vars['gender'];
	if (!empty($field->post_vars['dob']))		
		$sql_data_array['customers_dob'] = date_raw($field->post_vars['dob']);
	require(DIR_FS_INC.'inc.new_customer_id.php');
	$sql_data_array['customers_cid'] = new_customer_id();

	$db->db_perform(TABLE_CUSTOMERS, $sql_data_array);
	
	$user_id = $db->db_insert_id();
	
	require(DIR_FS_INC.'inc.write_user_info.php');
	$_SESSION['customer_id'] = $user_id;
	write_user_info($user_id);
	
	$sql_info_array = array('customers_info_id' => '1',
							'customers_info_date_of_last_logon' => '1',
							'customers_info_number_of_logons' => 'NOW()',
							'customers_info_date_account_created' => 'NOW()');
	
	$db->db_perform(TABLE_CUSTOMERS_INFO, $sql_info_array);
	
	$sql_address_array = array('customers_id' => '1',
								'entry_firstname' => (!empty($field->post_vars['title']) ? $field->post_vars['title'].' ' : '' ).ucfirst(strtolower($field->post_vars['firstname'])),
								'entry_lastname' => ucfirst(strtolower($field->post_vars['lastname'])),
								'entry_street_address' => $field->post_vars['street_address'].' '.$field->post_vars['street_address_num'],
								'entry_postcode' => $field->post_vars['postcode'],
								'entry_city' => $field->post_vars['city'],
								'entry_country_id' => $field->post_vars['country'],
								'entry_zone_id' => $field->post_vars['zone_id'],
								'entry_state' => $field->post_vars['state'],
								'address_date_added' => 'NOW()',
								'address_last_modified' => 'NOW()');

	if (!empty($field->post_vars['gender']))
		$sql_address_array['entry_gender'] = $field->post_vars['gender'];
	if (!empty($field->post_vars['company']))
		$sql_address_array['entry_company'] = $field->post_vars['company'];
	if (!empty($suburb))
		$sql_address_array['entry_suburb'] = $field->post_vars['suburb'];
		
	$db->db_perform(TABLE_ADDRESS_BOOK, $sql_address_array);
	
	$db->db_query("UPDATE ".TABLE_CONFIGURATION." SET configuration_value='".$field->post_vars['email']. "' WHERE configuration_key = 'STORE_OWNER_EMAIL_ADDRESS'");
	$db->db_query("UPDATE ".TABLE_CONFIGURATION." SET configuration_value='".$store_name. "' WHERE configuration_key = 'STORE_NAME'");
	$db->db_query("UPDATE ".TABLE_CONFIGURATION." SET configuration_value='".$_POST['EMAIL_ADRESS_FROM']. "' WHERE configuration_key = 'EMAIL_FROM'");
	$db->db_query("UPDATE ".TABLE_CONFIGURATION." SET configuration_value='".$field->post_vars['country']. "' WHERE configuration_key = 'SHIPPING_ORIGIN_COUNTRY'");
	$db->db_query("UPDATE ".TABLE_CONFIGURATION." SET configuration_value='".$field->post_vars['state']. "' WHERE configuration_key = 'STORE_ZONE'");
	$db->db_query("UPDATE ".TABLE_CONFIGURATION." SET configuration_value='".$field->post_vars['postcode']. "' WHERE configuration_key = 'SHIPPING_ORIGIN_ZIP'");
	$db->db_query("UPDATE ".TABLE_CONFIGURATION." SET configuration_value='".$field->post_vars['company']. "' WHERE configuration_key = 'STORE_OWNER'");
	$db->db_query("UPDATE ".TABLE_CONFIGURATION." SET configuration_value='".(!empty($field->post_vars['company']) ? $field->post_vars['company']."\n" : '' ).(!empty($field->post_vars['title']) ? $field->post_vars['title'].' ' : '' ).ucfirst(strtolower($field->post_vars['firstname'])).' '.ucfirst(strtolower($field->post_vars['lastname']))."\n".$field->post_vars['street_address'].' '.$field->post_vars['street_address_num']."\n".$field->post_vars['postcode'].' '.$field->post_vars['city'].(!empty($field->post_vars['telephone']) ? "\n\nTel.: ".$field->post_vars['telephone']:'').(!empty($field->post_vars['fax']) ? "\nFax: ".$field->post_vars['fax']:'')."' WHERE configuration_key = 'STORE_NAME_ADDRESS'");

	$db->db_query("UPDATE ".TABLE_COUNTRIES." SET status='0' WHERE countries_id != '".($field->post_vars['country'])." '");

	$tax_normal = '';
	$ta_normal_text = '';
	$tax_special = '';
	$tax_special_text = '';
	
	switch ($field->post_vars['country']) {
		case '14': // Austria
			$tax_normal='20.0000';
			$tax_normal_text='UST 20%';
			$tax_special='10.0000';
			$tax_special_text='UST 10%';
			break;
			 
		case '21': // Belgien
			$tax_normal='21.0000';
			$tax_normal_text='UST 21%';
			$tax_special='6.0000';
			$tax_special_text='UST 6%';
			break;
			 
		case '57': // Dänemark
			$tax_normal='25.0000';
			$tax_normal_text='UST 25%';
			$tax_special='25.0000';
			$tax_special_text='UST 25%';
			break;
			 
		case '72': // Finnland
			$tax_normal='22.0000';
			$tax_normal_text='UST 22%';
			$tax_special='8.0000';
			$tax_special_text='UST 8%';
			break;
			 
		case '73': // Frankreich
			$tax_normal='19.6000';
			$tax_normal_text='UST 19.6%';
			$tax_special='2.1000';
			$tax_special_text='UST 2.1%';
			break;
			 
		case '81':	// Deutschland
			$tax_normal='19.0000';
			$tax_normal_text='UST 19%';
			$tax_special='7.0000';
			$tax_special_text='UST 7%';
			break;
			 
		case '84': // Griechenland
			$tax_normal='18.0000';
			$tax_normal_text='UST 18%';
			$tax_special='4.0000';
			$tax_special_text='UST 4%';
			break;
			 
		case '103':	// Irland
			$tax_normal='21.0000';
			$tax_normal_text='UST 21%';
			$tax_special='4.2000';
			$tax_special_text='UST 4.2%';
			break;
			 
		case '105':	// Italien
			$tax_normal='20.0000';
			$tax_normal_text='UST 20%';
			$tax_special='4.0000';
			$tax_special_text='UST 4%';
			break;
			 
		case '124':	// Luxemburg
			$tax_normal='15.0000';
			$tax_normal_text='UST 15%';
			$tax_special='3.0000';
			$tax_special_text='UST 3%';
			break;
			 
		case '150':	// Niederlande
			$tax_normal='19.0000';
			$tax_normal_text='UST 19%';
			$tax_special='6.0000';
			$tax_special_text='UST 6%';
			break;
			 
		case '171':	// Portugal
			$tax_normal='17.0000';
			$tax_normal_text='UST 17%';
			$tax_special='5.0000';
			$tax_special_text='UST 5%';
			break;
			 
		case '195':	// Spain
			$tax_normal='16.0000';
			$tax_normal_text='UST 16%';
			$tax_special='4.0000';
			$tax_special_text='UST 4%';
			break;
			 
		case '203':	// Schweden
			$tax_normal='25.0000';
			$tax_normal_text='UST 25%';
			$tax_special='6.0000';
			$tax_special_text='UST 6%';
			break;
			 
		case '222':	// UK
			$tax_normal='17.5000';
			$tax_normal_text='UST 17.5%';
			$tax_special='5.0000';
			$tax_special_text='UST 5%';
			break;
			 
		default : // Deutschland
			$tax_normal='19.0000';
			$tax_normal_text='UST 19%';
			$tax_special='7.0000';
			$tax_special_text='UST 7%';
			break;
	}

	// Steuersätze / tax_rates
	$db->db_query("INSERT INTO ".TABLE_TAX_RATES." (tax_rates_id, tax_zone_id, tax_class_id, tax_priority, tax_rate, tax_description, last_modified, date_added) VALUES (1, 5, 1, 1, '".$tax_normal."', '".$tax_normal_text."', '', '')");
	$db->db_query("INSERT INTO ".TABLE_TAX_RATES." (tax_rates_id, tax_zone_id, tax_class_id, tax_priority, tax_rate, tax_description, last_modified, date_added) VALUES (2, 5, 2, 1, '".$tax_special."', '".$tax_special_text."', '', '')");
	$db->db_query("INSERT INTO ".TABLE_TAX_RATES." (tax_rates_id, tax_zone_id, tax_class_id, tax_priority, tax_rate, tax_description, last_modified, date_added) VALUES (3, 6, 1, 1, '0.0000', 'EU-AUS-UST 0%', '', '')");
	$db->db_query("INSERT INTO ".TABLE_TAX_RATES." (tax_rates_id, tax_zone_id, tax_class_id, tax_priority, tax_rate, tax_description, last_modified, date_added) VALUES (4, 6, 2, 1, '0.0000', 'EU-AUS-UST 0%', '', '')");
	
	// Steuerklassen
    $db->db_query("INSERT INTO ".TABLE_TAX_CLASS." (tax_class_id, tax_class_title, tax_class_description, last_modified, date_added) VALUES (1, 'Standardsatz', '', '', now())");
    $db->db_query("INSERT INTO ".TABLE_TAX_CLASS." (tax_class_id, tax_class_title, tax_class_description, last_modified, date_added) VALUES (2, 'ermäßigter Steuersatz', '', NULL, now())");

    // Steuersätze
    $db->db_query("INSERT INTO ".TABLE_GEO_ZONES." (geo_zone_id, geo_zone_name, geo_zone_description, last_modified, date_added) VALUES (6, 'Steuerzone EU-Ausland', '', '', now())");
    $db->db_query("INSERT INTO ".TABLE_GEO_ZONES." (geo_zone_id, geo_zone_name, geo_zone_description, last_modified, date_added) VALUES (5, 'Steuerzone EU', 'Steuerzone für die EU', '', now())");
    $db->db_query("INSERT INTO ".TABLE_GEO_ZONES." (geo_zone_id, geo_zone_name, geo_zone_description, last_modified, date_added) VALUES (7, 'Steuerzone B2B', '', NULL, now())");

    // EU-Steuerzonen
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (14, 14, 0, 5, NULL, now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (21, 21, 0, 5, NULL, now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (55, 55, 0, 5, NULL,  now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (56, 56, 0, 5, NULL,  now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (57, 57, 0, 5, NULL, now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (67, 67, 0, 5, NULL,  now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (72, 72, 0, 5, NULL, now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (73, 73, 0, 5, NULL, now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (81, 81, 0, 5, NULL, now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (84, 84, 0, 5, NULL, now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (97, 97, 0, 5, NULL,  now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (103, 103, 0, 5, NULL,now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (105, 105, 0, 5, NULL, now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (117, 117, 0, 5, NULL,  now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (123, 123, 0, 5, NULL,  now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (124, 124, 0, 5, NULL, now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (132, 132, 0, 5, NULL,  now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (150, 150, 0, 5, NULL, now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (170, 170, 0, 5, NULL,  now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (171, 171, 0, 5, NULL, now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (189, 189, 0, 5, NULL,  now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (190, 190, 0, 5, NULL,  now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (195, 195, 0, 5, NULL, now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (203, 203, 0, 5, NULL, now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (222, 222, 0, 5, NULL, now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (1, 1, 0, 6, NULL, now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (2, 2, 0, 6, NULL, now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (3, 3, 0, 6, NULL, now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (4, 4, 0, 6, NULL, now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (5, 5, 0, 6, NULL, now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (6, 6, 0, 6, NULL, now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (7, 7, 0, 6, NULL, now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (8, 8, 0, 6, NULL, now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (9, 9, 0, 6, NULL, now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (10, 10, 0, 6, NULL, now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (11, 11, 0, 6, NULL, now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (12, 12, 0, 6, NULL, now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (13, 13, 0, 6, NULL, now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (15, 15, 0, 6, NULL, now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (16, 16, 0, 6, NULL, now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (17, 17, 0, 6, NULL, now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (18, 18, 0, 6, NULL, now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (19, 19, 0, 6, NULL, now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (20, 20, 0, 6, NULL, now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (22, 22, 0, 6, NULL, now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (23, 23, 0, 6, NULL, now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (24, 24, 0, 6, NULL, now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (25, 25, 0, 6, NULL, now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (26, 26, 0, 6, NULL, now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (27, 27, 0, 6, NULL, now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (28, 28, 0, 6, NULL, now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (29, 29, 0, 6, NULL, now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (30, 30, 0, 6, NULL, now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (31, 31, 0, 6, NULL, now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (32, 32, 0, 6, NULL, now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (33, 33, 0, 6, NULL, now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (34, 34, 0, 6, NULL, now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (35, 35, 0, 6, NULL, now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (36, 36, 0, 6, NULL, now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (37, 37, 0, 6, NULL, now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (38, 38, 0, 6, NULL, now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (39, 39, 0, 6, NULL, now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (40, 40, 0, 6, NULL,  now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (41, 41, 0, 6, NULL,  now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (42, 42, 0, 6, NULL,  now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (43, 43, 0, 6, NULL,  now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (44, 44, 0, 6, NULL,  now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (45, 45, 0, 6, NULL,  now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (46, 46, 0, 6, NULL,  now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (47, 47, 0, 6, NULL,  now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (48, 48, 0, 6, NULL,  now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (49, 49, 0, 6, NULL,  now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (50, 50, 0, 6, NULL,  now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (51, 51, 0, 6, NULL,  now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (52, 52, 0, 6, NULL,  now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (53, 53, 0, 6, NULL,  now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (54, 54, 0, 6, NULL,  now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (58, 58, 0, 6, NULL,  now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (59, 59, 0, 6, NULL,  now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (60, 60, 0, 6, NULL,  now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (61, 61, 0, 6, NULL,  now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (62, 62, 0, 6, NULL,  now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (63, 63, 0, 6, NULL,  now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (64, 64, 0, 6, NULL,  now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (65, 65, 0, 6, NULL,  now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (66, 66, 0, 6, NULL,  now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (68, 68, 0, 6, NULL,  now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (69, 69, 0, 6, NULL,  now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (70, 70, 0, 6, NULL,  now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (71, 71, 0, 6, NULL,  now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (74, 74, 0, 6, NULL,  now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (75, 75, 0, 6, NULL,  now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (76, 76, 0, 6, NULL,  now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (77, 77, 0, 6, NULL,  now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (78, 78, 0, 6, NULL,  now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (79, 79, 0, 6, NULL,  now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (80, 80, 0, 6, NULL,  now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (82, 82, 0, 6, NULL,  now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (83, 83, 0, 6, NULL,  now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (85, 85, 0, 6, NULL,  now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (86, 86, 0, 6, NULL,  now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (87, 87, 0, 6, NULL,  now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (88, 88, 0, 6, NULL,  now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (89, 89, 0, 6, NULL,  now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (90, 90, 0, 6, NULL,  now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (91, 91, 0, 6, NULL,  now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (92, 92, 0, 6, NULL,  now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (93, 93, 0, 6, NULL,  now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (94, 94, 0, 6, NULL,  now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (95, 95, 0, 6, NULL,  now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (96, 96, 0, 6, NULL,  now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (98, 98, 0, 6, NULL,  now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (99, 99, 0, 6, NULL,  now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (100, 100, 0, 6, NULL,  now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (101, 101, 0, 6, NULL,  now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (102, 102, 0, 6, NULL,  now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (104, 104, 0, 6, NULL,  now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (106, 106, 0, 6, NULL,  now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (107, 107, 0, 6, NULL,  now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (108, 108, 0, 6, NULL,  now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (109, 109, 0, 6, NULL,  now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (110, 110, 0, 6, NULL,  now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (111, 111, 0, 6, NULL,  now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (112, 112, 0, 6, NULL,  now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (113, 113, 0, 6, NULL,  now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (114, 114, 0, 6, NULL,  now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (115, 115, 0, 6, NULL,  now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (116, 116, 0, 6, NULL,  now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (118, 118, 0, 6, NULL,  now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (119, 119, 0, 6, NULL,  now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (120, 120, 0, 6, NULL,  now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (121, 121, 0, 6, NULL,  now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (122, 122, 0, 6, NULL,  now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (125, 125, 0, 6, NULL,  now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (126, 126, 0, 6, NULL,  now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (127, 127, 0, 6, NULL,  now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (128, 128, 0, 6, NULL,  now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (129, 129, 0, 6, NULL,  now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (130, 130, 0, 6, NULL,  now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (131, 131, 0, 6, NULL,  now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (133, 133, 0, 6, NULL,  now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (134, 134, 0, 6, NULL,  now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (135, 135, 0, 6, NULL,  now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (136, 136, 0, 6, NULL,  now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (137, 137, 0, 6, NULL,  now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (138, 138, 0, 6, NULL,  now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (139, 139, 0, 6, NULL,  now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (140, 140, 0, 6, NULL,  now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (141, 141, 0, 6, NULL,  now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (142, 142, 0, 6, NULL,  now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (143, 143, 0, 6, NULL,  now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (144, 144, 0, 6, NULL,  now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (145, 145, 0, 6, NULL,  now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (146, 146, 0, 6, NULL,  now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (147, 147, 0, 6, NULL,  now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (148, 148, 0, 6, NULL,  now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (149, 149, 0, 6, NULL,  now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (151, 151, 0, 6, NULL,  now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (152, 152, 0, 6, NULL,  now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (153, 153, 0, 6, NULL,  now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (154, 154, 0, 6, NULL,  now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (155, 155, 0, 6, NULL,  now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (156, 156, 0, 6, NULL,  now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (157, 157, 0, 6, NULL,  now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (158, 158, 0, 6, NULL,  now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (159, 159, 0, 6, NULL,  now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (160, 160, 0, 6, NULL,  now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (161, 161, 0, 6, NULL,  now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (162, 162, 0, 6, NULL,  now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (163, 163, 0, 6, NULL,  now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (164, 164, 0, 6, NULL,  now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (165, 165, 0, 6, NULL,  now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (166, 166, 0, 6, NULL,  now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (167, 167, 0, 6, NULL,  now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (168, 168, 0, 6, NULL,  now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (169, 169, 0, 6, NULL,  now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (172, 172, 0, 6, NULL,  now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (173, 173, 0, 6, NULL,  now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (174, 174, 0, 6, NULL,  now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (175, 175, 0, 6, NULL,  now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (176, 176, 0, 6, NULL,  now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (177, 177, 0, 6, NULL,  now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (178, 178, 0, 6, NULL,  now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (179, 179, 0, 6, NULL,  now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (180, 180, 0, 6, NULL,  now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (181, 181, 0, 6, NULL,  now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (182, 182, 0, 6, NULL,  now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (183, 183, 0, 6, NULL,  now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (184, 184, 0, 6, NULL,  now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (185, 185, 0, 6, NULL,  now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (186, 186, 0, 6, NULL,  now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (187, 187, 0, 6, NULL,  now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (188, 188, 0, 6, NULL,  now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (191, 191, 0, 6, NULL,  now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (192, 192, 0, 6, NULL,  now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (193, 193, 0, 6, NULL,  now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (194, 194, 0, 6, NULL,  now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (196, 196, 0, 6, NULL,  now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (197, 197, 0, 6, NULL,  now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (198, 198, 0, 6, NULL,  now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (199, 199, 0, 6, NULL,  now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (200, 200, 0, 6, NULL,  now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (201, 201, 0, 6, NULL,  now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (202, 202, 0, 6, NULL,  now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (204, 204, 0, 6, NULL,  now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (205, 205, 0, 6, NULL,  now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (206, 206, 0, 6, NULL,  now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (207, 207, 0, 6, NULL,  now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (208, 208, 0, 6, NULL,  now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (209, 209, 0, 6, NULL,  now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (210, 210, 0, 6, NULL,  now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (211, 211, 0, 6, NULL, now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (212, 212, 0, 6, NULL, now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (213, 213, 0, 6, NULL, now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (214, 214, 0, 6, NULL, now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (215, 215, 0, 6, NULL, now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (216, 216, 0, 6, NULL, now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (217, 217, 0, 6, NULL, now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (218, 218, 0, 6, NULL, now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (219, 219, 0, 6, NULL, now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (220, 220, 0, 6, NULL, now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (221, 221, 0, 6, NULL, now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (223, 223, 0, 6, NULL, now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (224, 224, 0, 6, NULL, now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (225, 225, 0, 6, NULL, now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (226, 226, 0, 6, NULL, now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (227, 227, 0, 6, NULL, now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (228, 228, 0, 6, NULL, now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (229, 229, 0, 6, NULL, now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (230, 230, 0, 6, NULL, now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (231, 231, 0, 6, NULL, now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (232, 232, 0, 6, NULL, now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (233, 233, 0, 6, NULL, now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (234, 234, 0, 6, NULL, now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (235, 235, 0, 6, NULL, now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (236, 236, 0, 6, NULL, now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (237, 237, 0, 6, NULL, now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (238, 238, 0, 6, NULL, now())");
    $db->db_query("INSERT INTO ".TABLE_ZONES_TO_GEO_ZONES." (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (239, 239, 0, 6, NULL, now())");
	
	$db->db_query("UPDATE ".TABLE_EMAILS." SET email_address = '".$_POST['EMAIL_ADRESS_FROM']."', email_replay_address = '".$_POST['EMAIL_ADRESS_FROM']."' ");
	$db->db_query("UPDATE ".TABLE_EMAILS." SET email_address_name = '".STORE_NAME."'");
	$db->db_query("UPDATE ".TABLE_CONFIGURATION." SET configuration_value = '".$_POST['EMAIL_ADRESS_FROM']. "' WHERE configuration_key = 'GLOBAL_EMAIL_ADDRESS'");
	$db->db_query("UPDATE ".TABLE_CONFIGURATION." SET configuration_value = '".STORE_NAME. "' WHERE configuration_key = 'GLOBAL_EMAIL_ADDRESS_NAME'");
	$db->db_query("UPDATE ".TABLE_CONFIGURATION." SET configuration_value = '".$_POST['EMAIL_ADRESS_FROM']. "' WHERE configuration_key = 'GLOBAL_EMAIL_REPLAY_ADDRESS'");
	$db->db_query("UPDATE ".TABLE_CONFIGURATION." SET configuration_value = '".STORE_NAME. "' WHERE configuration_key = 'GLOBAL_EMAIL_REPLAY_ADDRESS_NAME'");
	
	redirect('index.php?step=4');
}
include('includes/metatag.php');
?>
<title>SEO:mercari Installation - Schritt 3</title>
<script type="text/javascript">
	$(function(){
		$('#pass').keyup(function(){passwordStrength($(this).val());});
	});
	function passwordStrength(password){
		if (password.length > 0) {
			var desc = new Array();
			desc[1] = "sehr schwach";
			desc[2] = "schwach";
			desc[3] = "besser";
			desc[4] = "geht so";
			desc[5] = "gut";
			desc[6] = "sehr gut";
	
			var score = 1;
			if (password.length > 6) score++;
			if (password.match(/[a-z]/)) score++; 
			if (password.match(/[A-Z]/)) score++;
			if (password.match(/\d+/)) score++;
			if (password.match(/.[!,@,#,$,%,^,&,*,?,:,_,~,-,(,)]/) ) score++;
			if (password.length > 12) score++;
			document.getElementById("passwordDescription").innerHTML = desc[score];
			document.getElementById("passwordStrength").className = "strength" + score;
		} else {
			document.getElementById("passwordDescription").innerHTML = 'Passwortstärke:';
			document.getElementById("passwordStrength").className = "strength0";
		}
	}
	function setMailAdress() {
		var data = $('#mail_address').val();
		$('#mail_from').val(data);
	}
</script>
</head>
<body>
<script type="text/javascript">
	$(function(){
		$("select#country").change(function(){
			var value = $("select#country").val();
			$.ajax({
			  type: "GET",
			  url: "../includes/javascript/helper/get_states.php",
			  data: "land=" + value,
			  cache: false,
			  success: function(html){
			    $("#provice").html(html);
			  },
			  beforeSend: function(html){
			  	$("#state").html("<p style=\'width:215px\' align=\'center\'><img src=\'images/wait.gif\' alt=\'\' /></p>");
			  }
			});
		});
	});
</script>
<script type="text/javascript" src="includes/javascript/tooltip.js" encode="UTF-8"></script>
<?php include('includes/header.php'); ?>
<div id="wrapper">
	<div id="inner_wrapper">
		<table class="outerTable" width="100%" cellpadding="4">
			<tr>
				<td class="columnRight" valign="top">
					<table class="table_pageHeading" border="0" width="100%" cellspacing="0" cellpadding="0">
						<tr>
							<td class="pageHeading">
								<h1 class="schatten">Schritt 3</h1>
							</td>
						</tr>
					</table>
					<?php echo TEXT_WELCOME_STEP6; ?>

					<h2 class="schatten">
						<?php echo TITLE_ADMIN_CONFIG; ?>
						<?php echo ' <span'.mouseOverJS('Notiz',TITLE_ADMIN_CONFIG_NOTE).'>
							<img src="images/icons/information-balloon.png" alt="" />
						</span>'; ?>
					</h2>
					<p align="right"><span style="color:#b20000"><b><?php echo TEXT_REQU_INFORMATION; ?></b></span></p>
					<form name="install" action="index.php?step=3" method="post" autocomplete="off">
              			<input name="action" type="hidden" value="process" />
              			<table cellpadding="8" cellspacing="8" class="table_input" width="100%">
              				<tr>
              					<td valign="middle" width="150">
              					    <b>Anrede:</b>
              					</td>
              					<td valign="middle">
              						<?php echo $gender_female; ?> Frau<br />
              						<?php echo $gender_male; ?> Herr
              					</td>
              				</tr>
              			</table>
              			<table cellpadding="8" cellspacing="8" class="table_input" width="100%">
              				<tr>
              					<td valign="middle" width="150">
              					    <b>Titel:</b>
              					</td>
              					<td valign="middle">
              						<?php echo $title; 
              						?>
              					</td>
              				</tr>
              			</table>
              			<table cellpadding="8" cellspacing="8" class="table_input" width="100%">
              				<tr>
              					<td valign="middle" width="150">
              					    <b><?php echo TEXT_FIRSTNAME; ?></b>
              					</td>
              					<td valign="middle">
              						<?php echo $firstname;?>
              					</td>
              				</tr>
              			</table>
              			<table cellpadding="8" cellspacing="8" class="table_input" width="100%">
              				<tr>
              					<td valign="middle" width="150">
              					    <b><?php echo TEXT_LASTNAME; ?></b>
              					</td>
              					<td valign="middle">
              						<?php echo $lastname;?>
              					</td>
              				</tr>
              			</table>
              			<table cellpadding="8" cellspacing="8" class="table_input" width="100%">
              				<tr>
              					<td valign="middle" width="150">
              					    <b><?php echo TEXT_EMAIL; ?></b>
              					</td>
              					<td valign="middle">
              						<?php echo $email_address;?>
              						<?php echo ' <span'.mouseOverJS(TEXT_EMAIL,TEXT_EMAIL_LONG).'>
									<img src="images/icons/information-balloon.png" alt="" />
									</span>'; ?>
              					</td>
              				</tr>
              			</table>
              			<table cellpadding="8" cellspacing="8" class="table_input" width="100%">
              				<tr>
              					<td valign="middle" width="150">
              					    <b>Geburtsdatum:</b>
              					</td>
              					<td valign="middle">
              						<?php echo $dob;?>
              						<em>DD.MM.YYYY</em>
              					</td>
              				</tr>
              			</table>
              			<table cellpadding="8" cellspacing="8" class="table_input" width="100%">
              				<tr>
              					<td valign="middle" width="150">
              					    <b><?php echo TEXT_STREET; ?></b><br />
              					    <b><?php echo TEXT_STREET_NUM; ?></b>
              					</td>
              					<td valign="middle">
              						<?php echo $street_address; ?><br />
              						<?php echo $street_address_num; ?>
              					</td>
              				</tr>
              			</table>
              			<table cellpadding="8" cellspacing="8" class="table_input" width="100%">
              				<tr>
              					<td valign="middle" width="150">
              					    <b><?php echo TEXT_POSTCODE; ?></b><br />
              					    <b><?php echo TEXT_CITY; ?></b>
              					</td>
              					<td valign="middle">
              						<?php echo $postcode;?><br />
              						<?php echo $city;?>
              					</td>
              				</tr>
              			</table>
              			<table cellpadding="8" cellspacing="8" class="table_input" width="100%">
              				<tr>
              					<td valign="middle" width="150">
              					    <b><?php echo TEXT_COUNTRY; ?></b>
              					</td>
              					<td valign="middle">
              						<?php echo $country;?>
              						<?php echo ' <span'.mouseOverJS(TEXT_COUNTRY,TEXT_COUNTRY_LONG).'>
									<img src="images/icons/information-balloon.png" alt="" />
									</span>'; ?>
              					</td>
              				</tr>
              			</table>
              			<table cellpadding="8" cellspacing="8" class="table_input" width="100%">
              				<tr>
              					<td valign="middle" width="150">
              					    <b><?php echo TEXT_STATE; ?></b>
              					</td>
              					<td valign="middle">
              						<div id="provice">
              							<?php echo $state; ?>
              						</div>
              					</td>
              				</tr>
              			</table>
              			<table cellpadding="8" cellspacing="8" class="table_input" width="100%">
              				<tr>
              					<td valign="middle" width="150">
              					    <b><?php echo TEXT_TEL; ?></b>
              					</td>
              					<td valign="middle">
              						<?php echo $telephone; ?>
              					</td>
              				</tr>
              			</table>
              			<table cellpadding="8" cellspacing="8" class="table_input" width="100%">
              				<tr>
              					<td valign="middle" width="150">
              					    <b>Fax:</b>
              					</td>
              					<td valign="middle">
              						<?php echo $fax; ?>
              					</td>
              				</tr>
              			</table>
                		<table cellpadding="8" cellspacing="8" class="table_input" width="100%">
                			<tr>
                				<td valign="middle" width="150">
                				    <b><?php echo TEXT_PASSWORD; ?></b>
                				</td>
                				<td valign="middle">
                					<?php echo $password;?>
                				</td>
                			</tr>
                			<tr>
                				<td valign="middle" width="150">
                				    <b><?php echo TEXT_PASSWORD_CONF; ?></b>
                				</td>
                				<td valign="middle">
                					<?php echo $confirmation;?>
                				</td>
                			<tr>
                			<tr>
                				<td valign="middle" align="right">
                					<div id="passwordDescription"><?php echo TEXT_PASSWORD_STRONG; ?></div>
                				</td>
                				<td align="left">
									<div id="passwordStrength" class="strength0"></div>
                				</td>
                			</tr>
                		</table>
                		<h2 class="schatten">
                			<?php echo TITLE_SHOP_CONFIG; ?>
                			<?php echo ' <span'.mouseOverJS('Notiz',TITLE_SHOP_CONFIG_NOTE).'>
								<img src="images/icons/information-balloon.png" alt="" />
							</span>'; ?>
						</h2>
                		<table cellpadding="8" cellspacing="8" class="table_input" width="100%">
                			<tr>
                				<td valign="middle" width="150">
                				    <b><?php echo TEXT_STORE; ?></b>
                				</td>
                				<td valign="middle">
                					<?php echo draw_input_field_installer('STORE_NAME','','text','size="30"');?>
                					<span style="color:#b20000">*</span>
                					<?php echo ' <span'.mouseOverJS(TEXT_STORE,TEXT_STORE_LONG,'','200').'>
									<img src="images/icons/information-balloon.png" alt="" />
									</span>'; ?>
                				</td>
                			<tr>
                		</table>
              			<table cellpadding="8" cellspacing="8" class="table_input" width="100%">
              				<tr>
              					<td valign="middle" width="150">
              					    <b><?php echo TEXT_COMPANY; ?></b>
              					</td>
              					<td valign="middle">
              						<?php echo $company;?>
              					</td>
              				</tr>
              			</table>
              			<table cellpadding="8" cellspacing="8" class="table_input" width="100%">
              				<tr>
              					<td valign="middle" width="150">
              					    <b><?php echo TEXT_EMAIL_FROM; ?></b>
              					</td>
              					<td valign="middle">
              						<?php echo draw_input_field_installer('EMAIL_ADRESS_FROM','','text','size="30" id="mail_from"');?>
              						<span style="color:#b20000">*</span>
              						<?php echo ' <span'.mouseOverJS(TEXT_EMAIL_FROM,TEXT_EMAIL_FROM_LONG).'>
									<img src="images/icons/information-balloon.png" alt="" />
									</span>'; ?>
              					</td>
              				</tr>
              			</table>
              			<table cellpadding="8" cellspacing="8" width="100%">
              				<tr>
              					<td align="right" valign="middle">
              					    <input class="button" name="image" type="submit" value="weiter zu Schritt 4" />
              					</td>
              				</tr>
              			</table>
              		</form>
				</td>
			</tr>
		</table>
	</div>
</div>
<?php
	include('includes/footer.php');
?>
</body>
</html>